Qid Examcode Question Qimpath opt1 opt2 opt3 opt4 opt5 opt6 opt7 opt8 opt9 opt10 opt11 opt12 opt13 opt14 opt15 impath1 impath2 impath3 impath4 impath5 impath6 impath7 impath8 impath9 impath10 impath11 impath12 impath13 impath14 impath15 answers uanswer CR Edit Delete
300 1Z0-060 View the Exhibit and examine the structure of the PROMOTIONS table. 300-qupgrad.png WHERE promo_name NOT LIKE 'T%' OR promo_name NOT LIKE 'N%' AND promo_cost > 20000 AND promo_end_date > '1-JAN-01' WHERE (promo_name NOT LIKE 'T%' AND promo_name NOT LIKE 'N%')OR promo_cost > 20000 OR promo_end_date > '1-JAN-01' WHERE promo_name NOT LIKE 'T%' AND promo_name NOT LIKE 'N%' AND promo_cost > 20000 AND promo_end_date > '1-JAN-01' WHERE (promo_name NOT LIKE '%T%' OR promo_name NOT LIKE '%N%') AND(promo_cost > 20000 AND promo_end_date > '1-JAN-01') 3 SC edit delete
299 1Z0-060 You created an ORDERS table with the following description: 299-qupgrad.png You cannot add a primary key constraint if data exists in the column You can add the primary key constraint even if data exists, provided that there are no duplicate values The primary key constraint can be created only a the time of table creation You cannot have two constraints on one column 2 SC edit delete
298 1Z0-060 View the Exhibit and examine the structure of the CUSTOMERS and CUST_HISTORY tables. 298-qupgrad.png INTERSECT UNION ALL MINUS UNION 3 SC edit delete
297 1Z0-060 Examine the structure of the EMPLOYEES table: 297-qupgrad.png INSERT INTO employees (employee_id, first_name, last_name, hire_date) VALUES ( 1000, ,,John, ,,Smith, ,,01/01/01); INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES ( 1000, ,,John, ,,Smith, 01 January 01); INSERT INTO employees(employee_id, first_name, last_name, Hire_date) VALUES ( 1000, ,,John, ,,Smith, To_date(,,01/01/01)); INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES ( 1000, ,,John, ,,Smith, 01-Jan-01); 4 SC edit delete
296 1Z0-060 Which two statements are true regarding the USING and ON clauses in table joins? (Choose two.) The ON clause can be used to join tables on columns that have different names but compatible data types A maximum of one pair of columns can be joined between two tables using the ON clause Both USING and ON clause can be used for equijoins and nonequijoins The WHERE clause can be used to apply additional conditions in SELECT statement containing the ON or the USING clause 1, 4 MC edit delete
295 1Z0-060 See the Exhibit and examine the structure of the PROMOTIONS table: 295-qupgrad.png It generates an error because multiple conditions cannot be specified for the WHEN clause It executes successfully and gives the required result It generates an error because CASE cannot be used with group functions It generates an error because NULL cannot be specified as a return value 2 SC edit delete
294 1Z0-060 You work as a database administrator at ABC.com. You study the exhibit carefully. 294-qupgrad.png It would not execute because the SELECT statement cannot be used in place of the table name It would execute and restrict modifications to only the column specified in the SELECT statement It would not execute because a sub query cannot be used in the WHERE clause of an UPDATE statement It would not execute because two tables cannot be used in a single UPDATE statement 2 SC edit delete
293 1Z0-060 View the Exhibit and examine the data in the PROMOTIONS table. 293-qupgrad.png SELECT promo_category FROM promotions MINUS SELECT promo_category FROM promotions WHERE promo_subcategory = 'discount'; SELECT promo_category FROM promotions INTERSECT SELECT promo_category FROM promotions WHERE promo_subcategory = 'discount'; SELECT promo_category FROM promotions MINUS SELECT promo_category FROM promotions WHERE promo_subcategory <> 'discount'; SELECT promo_category FROM promotions INTERSECT SELECT promo_category FROM promotions WHERE promo_subcategory <> 'discount'; 1, 4 MC edit delete
292 1Z0-060 The STUDENT_GRADES table has these columns: 292-qupgrad.png SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN 01-JAN-2001 AND 31-DEC-2001 OR gpa > 3.; SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN 01-JAN-2001 AND 31-DEC-2001 AND gpa gt 3.0; SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN 01-JAN-2001 AND 31-DEC-2001 AND gpa > 3.0; SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN 01-JAN-2001 AND 31-DEC-2001 OR gpa > 3.0; SELECT student_id, gpa FROM student_grades WHERE semester_end > 01-JAN-2001 OR semester_end < 31-DEC-2001 AND gpa >= 3.0; 3 SC edit delete
291 1Z0-060 You need to create a table for a banking application. One of the columns in the table has the following requirements: 291-qupgrad.png INTERVAL YEAR TO MONTH NUMBER TIMESTAMP DATE INTERVAL DAY TO SECOND 5 SC edit delete
290 1Z0-060 View the Exhibit and examine the structure of the CUSTOMERS table. 290-qupgrad.png It produces an error and the < operator should be replaced by < ANY to get the required output It produces an error and the IN operator should be replaced by = in the WHERE clause of the main query to get the required output It executes and shows the required result It produces an error and the < operator should be replaced by < ALL to get the required output 3 SC edit delete
289 1Z0-060 View the Exhibit and examine the structure of the CUSTOMERS table. Evaluate the query 289-qupgrad.png It executes successfully. It produces an error because the condition on CUST_LAST_NAME is invalid. It executes successfully only if the CUST_CREDIT_LIMIT column does not contain any null values. It produces an error because the AND operator cannot be used to combine multiple BETWEEN clauses. 1 SC edit delete
288 1Z0-060 You need to display the first names of all customers from the CUSTOMERS table that contain the character 'e' and have the character 'a' in the second last position. Which query would give the required output? SELECT cust_first_name FROM customers WHERE INSTR(cust_first_name, 'e')<>0 AND SUBSTR(cust_first_name, -2, 1)='a'; SELECT cust_first_name FROM customers WHERE INSTR(cust_first_name, 'e')<>'' AND SUBSTR(cust_first_name, -2, 1)='a'; SELECT cust_first_name FROM customers WHERE INSTR(cust_first_name, 'e')IS NOT NULL AND SUBSTR(cust_first_name, 1,-2)='a'; SELECT cust_first_name FROM customers WHERE INSTR(cust_first_name, 'e')<>0 AND SUBSTR(cust_first_name, LENGTH(cust_first_name),-2)='a'; 1 SC edit delete
287 1Z0-060 View the Exhibit and examine the description for the PRODUCTS and SALES table. 287-qupgrad.png DELETE FROM products WHERE prod_id = (SELECT prod_id FROM sales WHERE time_id - 3*365 = SYSDATE ); DELETE FROM products WHERE prod_id = (SELECT prod_id FROM sales WHERE SYSDATE >= time_id - 3*365 ); DELETE FROM products WHERE prod_id IN (SELECT prod_id FROM sales WHERE SYSDATE - 3*365 >= time_id); DELETE FROM products WHERE prod_id IN (SELECT prod_id FROM sales WHERE time_id >= SYSDATE - 3*365 ); 3 SC edit delete
286 1Z0-060 View the Exhibit and examine the structure of the PROMOTIONS, SALES, and CUSTOMER tables. 286-qupgrad.png It executes successfully and gives the required result. It executes successfully but does not give the required result. It produces an error because the join order of the tables is incorrect. It produces an error because equijoin and nonequijoin conditions cannot be used in the same SELECT statement. 2 SC edit delete
285 1Z0-060 View the Exhibit and examine the structure of the CUSTOMERS table. 285-qupgrad.png SELECT cust_city, cust_income_level, cust_last_name FROM customers ORDER BY cust_city desc, cust_income_level DESC; SELECT cust_city, cust_income_level, cust_last_name FROM customers ORDER BY cust_income_level desc, cust_city DESC; SELECT cust_city, cust_income_level, cust_last_name FROM customers ORDER BY (cust_city, cust_income_level) DESC; SELECT cust_city, cust_income_level, cust_last_name FROM customers ORDER BY cust_city, cust_income_level DESC; 1 SC edit delete
284 1Z0-060 User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. 284-qupgrad.png CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu; CREATE PUBLIC SYNONYM EDL:VU FOR mary (emp_dept_loc_vu); CREATE PUBLIC SYNONYM EDL_VU FOR emp_dept_loc_vu; CREATE SYNONYM EDL_VU ON emp_dept_loc_vu FOR EACH USER; CREATE SYNONYM EDL_VU FOR EACH USER ON emp_dept_loc_vu; CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu FOR ALL USERS; 3 SC edit delete
283 1Z0-060 View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. 283-qupgrad.png A B C D 283-Aupans.png 283-Bupans.png 283-Cupans.png 283-Dupans.png 1 SC edit delete
282 1Z0-060 Examine the structure of the STUDENTS table: 282-qupgrad.png A B C D E 282-Aupans.png 282-Bupans.png 282-Cupans.png 282-Dupans.png 282-Eupans.png 4 SC edit delete
281 1Z0-060 The COMMISSION column shows the monthly commission earned by the employee. 281-qupgrad.png listing the employees who earn the same amount of commission as employee 3 finding the total commission earned by the employees in department 10 finding the number of employees who earn a commission that is higher than the average commission of the company listing the departments whose average commission is more that 600 listing the employees who do not earn commission and who are working for department 20 in descending order of the employee ID listing the employees whose annual commission is more than 6000 1, 3 MC edit delete
280 1Z0-060 Which view should a user query to display the columns associated with the constraints on a table owned by the user? USER_CONSTRAINTS USER_OBJECTS ALL_CONSTRAINTS USER_CONS_COLUMNS USER_COLUMNS 4 SC edit delete
279 1Z0-060 Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: 279-qupgrad.png A B C D E F G H 279-Aupans.png 279-Bupans.png 279-Cupans.png 279-Dupans.png 279-Eupans.png 279-Fupans.png 279-Gupans.png 279-Hupans.png 1 SC edit delete
278 1Z0-060 Which four are types of functions available in SQL? (Choose 4) string character integer calendar numeric translation date conversion 2, 5, 7, 8 MC edit delete
277 1Z0-060 Which statement correctly describes SQL and /SQL*Plus? Both SQL and /SQL*plus allow manipulation of values in the database. /SQL*Plus recognizes SQL statements and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements. /SQL*Plus is a language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server. SQL manipulates data and table definitions in the database; /SQL*Plus does not allow manipulation of values in the database. 1 SC edit delete
276 1Z0-060 Evaluate the following SQL statement: 276-qupgrad.png It produces an error because the ORDER BY clause should appear only at the end of a compound query-that is, with the last SELECT statement It executes successfully and displays rows in the descending order of PROMO_CATEGORY It executes successfully but ignores the ORDER BY clause because it is not located at the end of the compound statement It produces an error because positional notation cannot be used in the ORDER BY clause with SET operators 1 SC edit delete
275 1Z0-060 Which three SQL statements would display the value 1890.55 as $1,890.55? (Choose three.) SELECT TO_CHAR(1890.55,'$99G999D00') FROM DUAL; SELECT TO_CHAR(1890.55,'$9,999V99') FROM DUAL; SELECT TO_CHAR(1890.55,'$0G000D00') FROM DUAL; SELECT TO_CHAR(1890.55,'$99G999D99') FROM DUAL; SELECT TO_CHAR(1890.55,'$9,999D99') FROM DUAL; 1, 3, 4 MC edit delete
274 1Z0-060 Where can sub queries be used? (Choose all that apply) field names in the SELECT statement the FROM clause in the SELECT statement the HAVING clause in the SELECT statement the GROUP BY clause in the SELECT statement the WHERE clause in only the SELECT statement the WHERE clause in SELECT as well as all DML statements 1, 2, 3, 6 MC edit delete
273 1Z0-060 Evaluate these two SQL statements: 273-qupgrad.png The two statements produce identical results. The second statement returns a syntax error. There is no need to specify DESC because the results are sorted in descending order by default. The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement. 1 SC edit delete
272 1Z0-060 See the Exhibit and examine the structure of the CUSTOMERS table: 272-qupgrad.png SELECT cust_city, AVG(cust_credit_limit) FROM customers WHERE cust_city IN ('WASHINGTON','NEW YORK') GROUP BY cust_credit_limit, cust_city; SELECT cust_city, AVG(cust_credit_limit) FROM customers WHERE cust_city IN ('WASHINGTON','NEW YORK') GROUP BY cust_city,cust_credit_limit; SELECT cust_city, AVG(cust_credit_limit) FROM customers WHERE cust_city IN ('WASHINGTON','NEW YORK') GROUP BY cust_city; SELECT cust_city, AVG(NVL(cust_credit_limit,0)) FROM customers WHERE cust_city IN ('WASHINGTON','NEW YORK'); 3 SC edit delete
271 1Z0-060 Which three statements are true regarding sub queries? (Choose three.) Multiple columns or expressions can be compared between the main query and sub query Main query and sub query can get data from different tables Sub queries can contain GROUP BY and ORDER BY clauses Main query and sub query must get data from the same tables Sub queries can contain ORDER BY but not the GROUP BY clause Only one column or expression can be compared between the main query and subqeury 1, 2, 3 MC edit delete
270 1Z0-060 See the Exhibit and examine the structure and data in the INVOICE table: 270-qupgrad.png SELECT MAX(inv_date),MIN(cust_id) FROM invoice; SELECT MAX(AVG(SYSDATE - inv_date)) FROM invoice; SELECT (AVG(inv_date) FROM invoice; SELECT AVG(inv_date - SYSDATE),AVG(inv_amt) FROM invoice; 1, 4 MC edit delete
269 1Z0-060 Here is the structure and data of the CUST_TRANS table: 269-qupgrad.png SELECT transdate + '10' FROM cust_trans; SELECT * FROM cust_trans WHERE transdate = '01-01-07'; SELECT transamt FROM cust_trans WHERE custno > '11'; SELECT * FROM cust_trans WHERE transdate='01-JANUARY-07'; SELECT custno + 'A' FROM cust_trans WHERE transamt > 2000; 1, 3, 4 MC edit delete
268 1Z0-060 You need to design a student registration database that contains several tables storing academic information. 268-qupgrad.png CREATE TABLE student_grades (student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk REFERENCES (student_id) FOREIGN KEY students(student_id)); CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id)); CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT FOREIGN KEY (student_id) REFERENCES students(student_id)); CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id)); 4 SC edit delete
267 1Z0-060 Evaluate the SQL statement: 267-qupgrad.png It releases the storage space used by the table. It does not release the storage space used by the table. You can roll back the deletion of rows after the statement executes. You can NOT roll back the deletion of rows after the statement executes. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table 1, 4, 6 MC edit delete
266 1Z0-060 Evaluate the following two queries: 266-qupgrad.png Performance would improve in query 2 only if there are null values in the CUST_CREDIT_LIMIT column Performance would degrade in query 2 There would be no change in performance Performance would improve in query 2 3 SC edit delete
265 1Z0-060 You are currently located in Singapore and have connected to a remote database in Chicago. 265-qupgrad.png Number of days since the promo started based on the current Singapore data and time. An error because the ROUND function specified is invalid An error because the WHERE condition specified is invalid Number of days since the promo started based on the current Chicago data and time 4 SC edit delete
264 1Z0-060 Examine the structure of the MARKS table: 264-qupgrad.png SELECT student_name,subject1 FROM marks WHERE subject1 > AVG(subject1); SELECT student_name,SUM(subject1) FROM marks WHERE student_name LIKE 'R%'; SELECT SUM(subject1+subject2+subject3) FROM marks WHERE student_name IS NULL; SELECT SUM(DISTINCT NVL(subject1,0)), MAX(subject1) FROM marks WHERE subject1 > subject2; 3, 4 MC edit delete
263 1Z0-060 Examine these statements 263-qupgrad.png The set of statements contains an error and does not work. It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users. It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users. It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role. It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object. It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar. 3 SC edit delete
262 1Z0-060 You work as a database administrator at ABC.com. You study the exhibit carefully. 262-qupgrad.png UPDATE promotions SET promo_cost = promo_cost+ 100 WHERE TO_CHAR(promo_end_date, 'yyyy') > '2000'; SELECT promo_begin_date FROM promotions WHERE TO_CHAR(promo_begin_date,'mon dd yy')='jul 01 98'; UPDATE promotions SET promo_cost = promo_cost+ 100 WHERE promo_end_date > TO_DATE(SUBSTR('01-JAN-2000',8)); SELECT TO_CHAR(promo_begin_date,'dd/month') FROM promotions WHERE promo_begin_date IN (TO_DATE('JUN 01 98'), TO_DATE('JUL 01 98')); 1, 2 MC edit delete
261 1Z0-060 Which statements are correct regarding indexes? (Choose all that apply.) For each data manipulation language (DML) operation performed, the corresponding indexes are automatically updated. A nondeferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index. A FOREIGN KEY constraint on a column in a table automatically creates a non unique key When a table is dropped, the corresponding indexes are automatically dropped 1, 2, 4 MC edit delete
260 1Z0-060 Which arithmetic operations can be performed on a column by using a SQL function that is built into Oracle database? (Choose three.) addition subtraction raising to a power finding the quotient finding the lowest value 1, 3, 5 MC edit delete
259 1Z0-060 Evaluate the following SQL commands: 259-qupgrad.png You cannot use SYSDATE in the condition of a CHECK constraint. You cannot use the BETWEEN clause in the condition of a CHECK constraint. You cannot use the NEXTVAL sequence value as a DEFAULT value for a column. You cannot use ORD_NO and ITEM_NO columns as a composite primary key because ORD NO is also the FOREIGN KEY. 1, 3 MC edit delete
258 1Z0-060 View the Exhibit and examine the structure of the PROMOTIONS table. 258-qupgrad.png SELECT promo_name, promo_begin_date FROM promotions WHERE promo_begiii_date > '01-JAN-01' ORDER BY 2 DESC; SELECT promo_name. promo_begiii_date FROM promotions WHERE promo_begin_date > '01-JAN-01' ORDER BY promo_name DESC: SELECT promo_name. promo_begin_date FROM promotions WHERE promo_begin_date > '01-JAN-01' ORDER BY 1DESC: SELECT promo_name, promo_begin_date "START DATE" FROM promotions WHERE promo_begin_date > '01-JAN-01' ORDER BY "START DATE" DESC; 1, 4 MC edit delete
257 1Z0-060 Evaluate the following query: 257-qupgrad.png It produces an error because flower braces have been used. It produces an error because the data types are not matching. It executes successfully and introduces an 's at the end of each promo_name in the output. It executes successfully and displays the literal" {'s start date was} " for each row in the output. 3 SC edit delete
256 1Z0-060 You need to perform these tasks: 256-qupgrad.png A B C 256-Aupans.png 256-Bupans.png 256-Cupans.png 1 SC edit delete
255 1Z0-060 View the Exhibit and examine the structure of the PRODUCTS table. 255-qupgrad.png It produces a syntax error. The result remains unchanged. The total price value would be lower than the correct value. The total price value would be higher than the correct value. 2 SC edit delete
254 1Z0-060 You need to display the date ll-oct-2007 in words as "Eleventh of October, Two Thousand Seven". Which SQL statement would give the required result? SELECT TO_CHAR('ll-oct-2007'. 'miDdspth "of Month. Year') FROM DUAL: SELECT TO_CHAR(TO_DATE('ll-oct-2007'X 'miDdspth of month, year') FROM DUAL; SELECT TO_CHAR(TO_DATE('ll-oct-2007'), 'miDdthsp "of* Month. Year') FROM DUAL; SELECT TO_DATE(TO_CHAR('ll-oct-20077fiiiDdspth "of" Month. Year')) FROM DUAL: 1 SC edit delete
253 1Z0-060 View the Exhibit and examine the structure of the PROMOTIONS table. 253-qupgrad.png A B C D 253-Aupans.png 253-Bupans.png 253-Cupans.png 253-Dupans.png 1, 4 MC edit delete
252 1Z0-060 View the Exhibit and examine the structure of ORD and ORD_ITEMS tables. 252-qupgrad.png CREATE INDEX ord_idx1 ON ord(ord_no); CREATE INDEX ord_idx2 ON ord_items(ord_no); CREATE INDEX ord_idx3 ON ord_items(item_no); CREATE INDEX ord_idx4 ON ord,ord_items(ord_no, ord_date,qty); 2, 3 MC edit delete
251 1Z0-060 Which statement is true regarding the COALESCE function? It can have a maximum of five expressions in a list. It returns the highest NOT NULL value in the list for all rows. It requires that all expressions in the list must be of the same data type. It requires that at least one of the expressions in the list must have a NOT NULL value. 3 SC edit delete
250 1Z0-060 View the Exhibit for the structure of the STUDENT and FACULTY tables. 250-qupgrad.png Only statement 1 executes successfully and gives the required result. Only statement 2 executes successfully and gives the required result. Both statements 1 and 2 execute successfully and give different results. Both statements 1 and 2 execute successfully and give the same required result. 4 SC edit delete
249 1Z0-060 Examine the structure and data in the PRICE_LIST table: 249-qupgrad.png SELECT TO_CHAR(prod_price* .25.'$99.999.99') FROM PRICEJLIST: SELECT TO_CHAR(TO_NUMBER(prod_price)* .25.'$99.999.00') FROM PRICE_LIST; SELECT TO_CRAR(TO_NUMBER(prod_price.'S99.999.99')* .25.'$99.999.00') FROM PRICE_LIST: SELECT TO_NUMBER(TO_NUMBER(prod_price.,$99.999.99')* .25/$99.999.00') FROM PRICE_LIST: 3 SC edit delete
248 1Z0-060 You need to generate a list of all customer last names with their credit limits from the CUSTOMERS table. Those customers who do not have a credit limit should appear last in the list. Winch two queries would achieve the required result? (Choose two.) SELECT cust_last_name. cust_credit_limit FROM customers ORDER BY cust_credit_limit DESC: SELECT cust_last_name. cust_credit_limit FROM customers ORDER BY cust_credit_limit: SELECT cust_last_name. cust_credit_limit FROM customers ORDER BY cust_credit_limit NULLS LAST: SELECT cust_last_name. cust_credit_limit FROM customers ORDER BY cust_last_name. cust_credit_limit NULLS LAST: 2, 3 MC edit delete
247 1Z0-060 You need to calculate the number of days from 1st January 2007 till date . Dates are stored in the default format of dd-mon-rr. Which two SQL statements would give the required output? (Choose two.) SELECT SYSDATE - '01-JAN-2007' FROM DUAL: SELECT SYSDATE - TOJDATE(X)1/JANUARY/2007") FROM DUAL: SELECT SYSDATE - TOJDATE('01-JANUARY-2007') FROM DUAL: SELECT TO_CHAR(SYSDATE. 'DD-MON-YYYY') - '01-JAN-2007' FROM DUAL: SELECT TO_DATE(SYSDATE. *DD/MONTH/YYYY') - '01/JANUARY/2007' FROM DUAL: 2, 3 MC edit delete
246 1Z0-060 View the Exhibit and examine the data in the PRODUCTS table. 246-qupgrad.png It executes successfully but returns no result. It executes successfully and returns the required result. It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid. It generates an error because the condition specified for the PROD_CATEGORY column is not valid. 1 SC edit delete
245 1Z0-060 Which two statements are true regarding sub queries? (Choose two.) A sub query can retrieve zero or more rows. Only two sub queries can be placed at one level. A sub query can be used only in SQL query statements. A sub query can appeal* on either side of a comparison operator. There is no limit on the number of sub query levels in the WHERE clause of a SELECT statement. 1, 4 MC edit delete
244 1Z0-060 View the Exhibit and examine the data in the COSTS table. 244-qupgrad.png It executes and produces the required result. It produces an error because an expression cannot be used in the ORDER BY clause. It produces an error because the DESC option cannot be used with an expression in the ORDER BY clause. It produces an error because the expression in the ORDER BY clause should also be specified in the SELECT clause. 1 SC edit delete
243 1Z0-060 Examine the structure and data of the CUSTJTRANS table: 243-qupgrad.png SELECT transdate + '10' FROM custjrans; SELECT * FROM custjrans WHERE transdate = '01-01-07': SELECT transamt FROM custjrans WHERE custno > '11': SELECT * FROM custjrans WHERE transdate='01-JANUARY-07': SELECT custno - 'A' FROM custjrans WHERE transamt > 2000: 1, 3, 4 MC edit delete
242 1Z0-060 View the Exhibit and examine the structure of the PROMOTIONS table. 242-qupgrad.png statement 1 gives an error, statement 2 executes successfully statement 2 gives an error, statement 1 executes successfully statement 1 and statement 2 execute successfully and give the same output statement 1 and statement 2 execute successfully and give a different output 4 SC edit delete
241 1Z0-060 The following data exists in the PRODUCTS table: 241-qupgrad.png 152526**** **152525.99 152525** an error message 1 SC edit delete
240 1Z0-060 View the Exhibit and examine the structure of the CUSTOMERS table. Evaluate the following 240-qupgrad.png It executes successfully. It returns an error because the BETWEEN operator cannot be used in the HAVING clause. It returns an error because WHERE and HAVING clauses cannot be used in the same SELECT statement. It returns an error because WHERE and HAVING clauses cannot be used to apply conditions on the same column. 1 SC edit delete
239 1Z0-060 What is true regarding sub queries? The inner query always sorts the results of the outer query The outer query always sorts the results of the inner query The outer query must return a value to the outer query The inner query returns a value to the outer query The inner query must always return a value or the outer query will give an error 4 SC edit delete
238 1Z0-060 View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. 238-qupgrad.png A B C D E 238-Aupans.png 238-Bupans.png 238-Cupans.png 238-Dupans.png 238-Eupans.png 1 SC edit delete
237 1Z0-060 View the Exhibit to examine the description for the SALES table. Which views can have all DML operations performed on it? (Choose all that apply.) 237-qupgrad.png A B C D 237-Aupans.png 237-Bupans.png 237-Cupans.png 237-Dupans.png 1, 2 MC edit delete
236 1Z0-060 Which is the valid CREATE [TABLE statement? CREATE TABLE emp9$# (emp_no NUMBER(4)); CREATE TABLE 9emp$# (emp_no NUMBER(4)); CREATE TABLE emp*123 (emp_no NUMBER(4)); CREATE TABLE emp9$# (emp_no NUMBER(4). date DATE); 1 SC edit delete
235 1Z0-060 Evaluate the following SQL statement: 235-qupgrad.png ORDER BY 2,1 ORDER BY CUST_NO ORDER BY 2,cust_id ORDER BY "CUST_NO" ORDER BY "Last Name" 1, 3, 5 MC edit delete
234 1Z0-060 View the Exhibit and examine the structure of the CUSTOMERS table. 234-qupgrad.png SELECT cust_city, cust_income_level, MAX(cust_credit_limit ) FROM customers GROUP BY cust_city, cust_income_level, cust_credit_limit; SELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP BY cust_city, cust_income_level; SELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP BY cust_credit_limit, cust_income_level, cust_city ; SELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP BY cust_city, cust_income_level, MAX(cust_credit_limit); 2 SC edit delete
233 1Z0-060 View the Exhibits and examine the structures of the PRODUCTS SALES and CUSTOMERS tables. 233-qupgrad.png A B C D 233-Aupans.png 233-Bupans.png 233-Cupans.png 233-Dupans.png 1, 3 MC edit delete
232 1Z0-060 Which statement is true regarding sub queries? The LIKE operator cannot be used with single- row subqueries. The NOT IN operator is equivalent to IS NULL with single- row subqueries. =ANY and =ALL operators have the same functionality in multiple- row subqueries. The NOT operator can be used with IN, ANY, and ALL operators in multiple- row sbqueries. 4 SC edit delete
231 1Z0-060 View the Exhibit and examine the structure of the PROMOTIONS table. Evaluate the following SQL statement: 231-qupgrad.png WHERE SELECT GROUP BY ORDER BY 3 SC edit delete
230 1Z0-060 The PART_CODE column in the SPARES table contains the following list of values: 230-qupgrad.png It produces an error. It displays all values. It displays only the values A%_WQ123 and AB_WQ123 . It displays only the values A%_WQ123 and A%BWQ123 . It displays only the values A%BWQ123 and AB_WQ123. 4 SC edit delete
229 1Z0-060 View the Exhibit and examine the structure of the PRODUCTS table. You need to generate a report in the following format: 229-qupgrad.png SELECT prod_name || q'''s category is ' || prod_category CATEGORIES FROM products; SELECT prod_name || q'['s ]'category is ' || prod_category CATEGORIES FROM products; SELECT prod_name || q'\'s\' || ' category is ' || prod_category CATEGORIES FROM products; SELECT prod_name || q'<'s >' || 'category is ' || prod_category CATEGORIES FROM products; 3, 4 MC edit delete
228 1Z0-060 Evaluate the following SQL statement: 228-qupgrad.png It produces an error. It executes but returns no rows. It generates output for NULL as well as the other values produced by the sub query. It ignores the NULL value and generates output for the other values produced by the sub query. 3 SC edit delete
227 1Z0-060 View the Exhibit and examine the structure of the PROMOTIONS table. Which SQL statements are valid? (Choose all that apply.) 227-qupgrad.png SELECT promo_id. DECODE(NVL(promo_cost.O).promo_cost * 0.25. 100) "Discount" FROM promotions; SELECT promo id. DECODE(promo_cost. 10000. DECODE(promo_category. 'Gl promo_cost * 25. NULL). NULL) "Catcost" FROM promotions; SELECT promo_id. DECODE(NULLIF(promo_cost. 10000). NULL. promo_cost*.25, *N/A') "Catcost" FROM promotions; SELECT promo_id. DECODE(promo_cost. >10000. 'High'. <10000. 'Low') "Range"FROM promotions; 1, 2 MC edit delete
226 1Z0-060 Using the CUSTOMERS table, you need to generate a report that shows 50% of each credit amount in each income level. The report should NOT show any repeated credit amounts in each income level. Which query would give the required result? SELECT cust_income_level, DISTINCT cust_credit_limit * 0.50 AS "50% Credit Limit" FROM customers; SELECT DISTINCT cust_income_level, DISTINCT cust_credit_limit * 0.50 AS "50% Credit Limit" FROM customers; SELECT DISTINCT cust_income_level ' ' cust_credit_limit * 0.50 AS "50% Credit Limit" FROM customers; SELECT cust_income_level ' ' cust_credit_limit * 0.50 AS "50% Credit Limit" FROM customers; 3 SC edit delete
225 1Z0-060 You work as a database administrator at ABC.com. You study the exhibit carefully. 225-qupgrad.png It produces an error because the AMT_SPENT column contains a null value. It displays a bonus of 1000 for all customers whose AMT_SPENT is less than CREDIT_LIMIT. It displays a bonus of 1000 for all customers whose AMT_SPENT equals CREDIT_LIMIT, or AMT_SPENT is null. It produces an error because the TO_NUMBER function must be used to convert the result of the NULLIF function before it can be used by the NVL2 function. 3 SC edit delete
224 1Z0-060 The SQL statements executed in a user session as follows: 224-qupgrad.png Both the DELETE statements and the UPDATE statement are rolled back The rollback generates an error Only the DELETE statements are rolled back Only the seconds DELETE statement is rolled back No SQL statements are rolled back 2, 5 MC edit delete
223 1Z0-060 Examine the structure of the EMPLOYEES table: 223-qupgrad.png You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column. The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column. The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table. Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence. The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table. The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column. 3, 4 MC edit delete
222 1Z0-060 Which two statements are true about constraints? (Choose two.) The UNIQUE constraint does not permit a null value for the column. A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints. The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index. The NOT NULL constraint ensures that null values are not permitted for the column. 2, 4 MC edit delete
221 1Z0-060 See the Exhibit and examine the structure of ORD table: 221-qupgrad.png All the statements would execute successfully and the ORD_NO column would contain the value 2 for the CUST_ID 101. The CREATE SEQUENCE command would not execute because the minimum value and maximum value for the sequence have not been specified. The CREATE SEQUENCE command would not execute because the starting value of the sequence and the increment value have not been specified. All the statements would execute successfully and the ORD_NO column would have the value 20 for the CUST_ID 101 because the default CACHE value is 20. 1 SC edit delete
220 1Z0-060 Evaluate the following SQL statements: 220-qupgrad.png +00-300, +54-02,+00 11:12:10.123457 +00-300,+00-650,+00 11:12:10.123457 +25-00, +54-02, +00 11:12:10.123457 +25-00,+00-650,+00 11:12:10.123457 3 SC edit delete
219 1Z0-060 Which statement is true regarding the default behavior of the ORDER BY clause? In a character sort, the values are case-sensitive NULL values are not considered at all by the sort operation Only those columns that are specified in the SELECT list can be used in the ORDER BY clause Numeric values are displayed from the maximum to the minimum value if they have decimal positions 1 SC edit delete
218 1Z0-060 For which action can you use the TO_DATE function? Convert any date literal to a date Convert any numeric literal to a date Convert any character literal to a date Convert any date to a character literal Format 10-JAN-99 to ,,January 10 1999 3 SC edit delete
217 1Z0-060 Which three tasks can be performed using SQL functions built into Oracle Database? (Choose three.) Combining more than two columns or expressions into a single column in the output Displaying a date in a nondefault format Substituting a character string in a text expression with a specified string Finding the number of characters in an expression 2, 3, 4 MC edit delete
216 1Z0-060 Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"? SELECT TO_CHAR(TO_DATE('19-Mar-2001', ,,DD-Mon-YYYY), ,,fmDdspth "of" Month YYYY fmHH:MI:SS AM) NEW_DATE FROM dual; SELECT TO_CHAR(TO_DATE(19-Mar-2001, ,,DD-Mon-YYYY), ,,Ddspth "of" Month YYYY fmHH:MI:SS AM) NEW_DATE FROM dual; SELECT TO_CHAR(TO_DATE(19-Mar-2001, ,,DD-Mon-YYYY), ,,fmDdspth "of" Month YYYY HH:MI:SS AM) NEW_DATE FROM dual; SELECT TO_CHAR(TO_DATE(19-Mar-2001, ,,DD-Mon-YYYY), ,,fmDdspth "of" Month YYYYfmtHH:HI:SS AM') NEW_DATE FROM dual; 1 SC edit delete
215 1Z0-060 See the Exhibit and examine the structure of the PROMOSTIONS table: 215-qupgrad.png SELECT promo_id, DECODE(NVL(promo_cost,0), promo_cost, promo_cost * 0.25, 100) "Discount" FROM promotions; SELECT promo_id, DECODE(promo_cost, 10000, DECODE(promo_category, 'G1', promo_cost *.25, NULL), NULL) "Catcost" FROM promotions; SELECT promo_id, DECODE(NULLIF(promo_cost, 10000), NULL, promo_cost*.25, 'N/A') "Catcost" FROM promotions; SELECT promo_id, DECODE(promo_cost, >10000, 'High', <10000, 'Low') "Range" FROM promotions; 1, 2 MC edit delete
214 1Z0-060 Which three statements are true regarding sub queries? (Choose three.) Multiple columns or expressions can be compared between the main query and sub query Sub queries can contain GROUP BY and ORDER BY clauses Only one column or expression can be compared between the main query and subqeury Main query and sub query can get data from different tables Main query and sub query must get data from the same tables Sub queries can contain ORDER BY but not the GROUP BY clause 1, 2, 4 MC edit delete
213 1Z0-060 You want to create an ORD_DETAIL table to store details for an order placed having the following business requirement: 213-qupgrad.png A B C D 213-Aupans.png 213-Bupans.png 213-Cupans.png 213-Dupans.png 3 SC edit delete
212 1Z0-060 Which three statements/commands would cause a transaction to end? (Choose three.) COMMIT SELECT CREATE ROLLBACK SAVEPOINT 1, 3, 4 MC edit delete
211 1Z0-060 See the Exhibit and Examine the structure of SALES and PROMOTIONS tables: 211-qupgrad.png A B C D 211-Aupans.png 211-Bupans.png 211-Cupans.png 211-Dupans.png 2, 3, 4 MC edit delete
210 1Z0-060 Evaluate the following SQL statements: 210-qupgrad.png It allows you to update job IDs of the existing sales staff to any other job ID in the EMPLOYEES table It allows you to delete details of the existing sales staff from the EMPLOYEES table It allows you to insert rows into the EMPLOYEES table It allows you to insert IDs, last names, and job IDs of the sales staff from the view if it is used in multitable INSERT statements 2, 4 MC edit delete
209 1Z0-060 Which is a valid CREATE TABLE statement? CREATE TABLE EMP9$# AS (empid number(2)); CREATE TABLE EMP*123 AS (empid number(2)); CREATE TABLE PACKAGE AS (packid number(2)); CREATE TABLE 1EMP_TEST AS (empid number(2)); 1 SC edit delete
208 1Z0-060 You are currently located in Singapore and have connected to a remote database in Chicago. 208-qupgrad.png Number of days since the promo started based on the current Chicago data and time Number of days since the promo started based on the current Singapore data and time. An error because the WHERE condition specified is invalid An error because the ROUND function specified is invalid 1 SC edit delete
207 1Z0-060 See the Exhibit and examine the structure and data in the INVOICE table: 207-qupgrad.png SELECT MAX(inv_date),MIN(cust_id) FROM invoice; SELECT AVG(inv_date-SYSDATE),AVG(inv_amt) FROM invoice; SELECT MAX(AVG(SYSDATE-inv_date)) FROM invoice; SELECT AVG(inv_date) FROM invoice; 1, 2 MC edit delete
206 1Z0-060 A SELECT statement can be used to perform these three functions: 206-qupgrad.png difference, projection, join selection, projection, join selection, intersection, join intersection, projection, join difference, projection, product 2 SC edit delete
205 1Z0-060 View the Exhibit and examine the description for the CUSTOMERS table. 205-qupgrad.png A B C D 205-Aupans.png 205-Bupans.png 205-Cupans.png 205-Dupans.png 1 SC edit delete
204 1Z0-060 Examine the structure of the INVOICE table: 204-qupgrad.png SELECT inv_no,NVL2(inv_date,'Pending','Incomplete') FROM invoice; SELECT inv_no,NVL2(inv_amt,inv_date,'Not Available') FROM invoice; SELECT inv_no,NVL2(inv_date,sysdate-inv_date,sysdate) FROM invoice; SELECT inv_no,NVL2(inv_amt,inv_amt*.25,'Not Available') FROM invoice; 1, 3 MC edit delete
203 1Z0-060 What is true about sequences? The start value of the sequence is always 1. A sequence always increments by 1. The minimum value of an ascending sequence defaults to 1. The maximum value of descending sequence defaults to 1. 3 SC edit delete
202 1Z0-060 Which one is a system privilege? SELECT DELETE EXECUTE ALTER TABLE CREATE TABLE 5 SC edit delete
201 1Z0-060 You work as a database administrator at ABC.com. You study the exhibit carefully. 201-qupgrad.png The column alias should be put in uppercase and enclosed within double quotation marks in the WHERE clause The parenthesis should be added to enclose the entire expression The column alias should be replaced with the expression in the WHERE clause The double quotation marks should be removed from the column alias 3 SC edit delete
200 1Z0-060 Which statement is true regarding synonyms? Synonyms can be created only for a table Synonyms are used to reference only those tables that are owned by another user The DROP SYNONYM statement removes the synonym and the table on which the synonym has been created becomes invalid A public synonym and a private synonym can exist with the same name for the same table 4 SC edit delete
199 1Z0-060 You work as a database administrator at ABC.com. You study the exhibit carefully. 199-qupgrad.png An alias cannot be used in an expression The alias MIDPOINT should be enclosed within double quotation marks for the CUST_CREDIT_LIMIT/2 expression The MIDPOINT +100 expression gives an error because CUST_CREDIT_LIMIT contains NULL values The alias NAME should not be enclosed within double quotation marks 1 SC edit delete
198 1Z0-060 The STUDENT_GRADES table has these columns: 198-qupgrad.png SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end DESC, gpa DESC; SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end, gpa ASC SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC, semester_end ASC; SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC, semester_end DESC; SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC, semester_end ASC; SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end,gpa DESC 6 SC edit delete
197 1Z0-060 You work as a database administrator at ABC.com. You study the exhibit carefully and examine the structure of CUSTOMRS AND SALES tables. 197-qupgrad.png It would execute and restrict modifications to only the column specified in the SELECT statement It would not execute because two tables cannot be used in a single UPDATE statement It would not execute because a sub query cannot be used in the WHERE clause of an UPDATE statement It would not execute because the SELECT statement cannot be used in place of the table name 1 SC edit delete
196 1Z0-060 Which statement is true regarding the INTERSECT operator? It ignores NULL values The number of columns and data types must be identical for all SELECT statements in the query The names of columns in all SELECT statements must be identical Reversing the order of the intersected tables the result 2 SC edit delete
195 1Z0-060 You need to display the date 11-Oct-2007 in words as ,,Eleventh of October, Two Thousand Seven. Which SQL statement would give the required result? SELECT TO_CHAR('11-oct-2007', 'fmDdspth "of" Month, Year') FROM DUAL; SELECT TO_CHAR(TO_DATE('11-oct-2007'), 'fmDdspth of month, year') FROM DUAL; SELECT TO_CHAR(TO_DATE('11-oct-2007'), 'fmDdthsp "of" Month, Year') FROM DUAL; SELECT TO_DATE(TO_CHAR('11-oct-2007','fmDdspth ''of'' Month, Year')) FROM DUAL; 3 SC edit delete
194 1Z0-060 The CUSTOMERS table has the following structure: 194-qupgrad.png SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND tax_amount IS NOT NULL; SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND cust_credit_limit IS NOT NULL; SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE cust_income_level <> NULL AND tax_amount <> NULL; SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE (cust_income_level,tax_amount) IS NOT NULL; 2 SC edit delete
193 1Z0-060 See the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and ITEMS tables: 193-qupgrad.png The NEW_SALES table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match The NEW_SALES table would get created and all the NOT NULL constraints defined on the specified columns would be passed to the new table The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the specified columns would be passed to the new table 2 SC edit delete
192 1Z0-060 You work as a database administrator at ABC.com. You study the exhibit carefully. 192-qupgrad.png A B C D 192-Aupans.png 192-Bupans.png 192-Cupans.png 192-Dupans.png 2, 3 MC edit delete
191 1Z0-060 Which is an iSQL*Plus command? INSERT UPDATE SELECT DESCRIBE DELETE RENAME 4 SC edit delete
190 1Z0-060 The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? GRANT select ON dept TO ALL_USERS; GRANT select ON dept TO ALL; GRANT QUERY ON dept TO ALL_USERS GRANT select ON dept TO PUBLIC; 4 SC edit delete
189 1Z0-060 When does a transaction complete? (Choose all that apply.) When a PL/SQL anonymous block is executed When a DELETE statement is executed When a data definition language statement is executed When a TRUNCATE statement is executed after the pending transaction When a ROLLBACK command is executed 3, 4, 5 MC edit delete
188 1Z0-060 Which object privileges can be granted on a view? none DELETE, INSERT,SELECT ALTER, DELETE, INSERT, SELECT DELETE, INSERT, SELECT, UPDATE 4 SC edit delete
187 1Z0-060 The PRODUCTS table has the following structure: 187-qupgrad.png Both the statements execute and give the same result Both the statements execute and give different results Only the second SQL statement executes successfully Only the first SQL statement executes successfully 2 SC edit delete
186 1Z0-060 View the Exhibit and evaluate structures of the SALES, PRODUCTS, and COSTS tables. 186-qupgrad.png It shows products that have a cost recorded irrespective of sales It shows products that were sold and have a cost recorded It shows products that were sold but have no cost recorded It reduces an error 3 SC edit delete
185 1Z0-060 Examine the structure of the EMPLOYEES table: 185-qupgrad.png A B C D 185-Aupans.png 185-Bupans.png 185-Cupans.png 185-Dupans.png 4 SC edit delete
184 1Z0-060 View the Exhibits and examine the structures of the PROMOTIONS and SALES tables. 184-qupgrad.png It gives details of product IDs that have been sold irrespective of whether they had a promo or not It gives the details of promos for which there have been no sales It gives the details of promos for which there have been sales It gives details of all promos irrespective of whether they have resulted in a sale or not 4 SC edit delete
183 1Z0-060 Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: 183-qupgrad.png DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees); DELETE * FROM employees WHERE employee_id=(SELECT employee_id FROM new_employees); DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = ,,Carrey); DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = ,,Carrey); 3 SC edit delete
182 1Z0-060 Which two statements are true regarding views? (Choose two.) A sub query that defines a view cannot include the GROUP BY clause A view is created with the sub query having the DISTINCT keyword can be updated A Data Manipulation Language (DML) operation can be performed on a view that is created with the sub query having all the NOT NULL columns of a table A view that is created with the sub query having the pseudo column ROWNUM keyword cannot be updated 3, 4 MC edit delete
181 1Z0-060 Which three are true? (Choose three.) A MERGE statement is used to merge the data of one table with data from another. A MERGE statement replaces the data of one table with that of another. A MERGE statement can be used to insert new rows into a table. A MERGE statement can be used to update existing rows in a table. 1, 3, 4 MC edit delete
180 1Z0-060 Which three statements are true regarding the data types in Oracle Database 10g/11g? (Choose three.) The BLOB data type column is used to store binary data in an operating system file The minimum column width that can be specified for a VARCHAR2 data type column is one A TIMESTAMP data type column stores only time values with fractional seconds The value for a CHAR data type column is blank-padded to the maximum defined column width Only One LONG column can be used per table 2, 4, 5 MC edit delete
179 1Z0-060 You work as a database administrator at ABC.com. You study the exhibit carefully. 179-qupgrad.png The view will be created and you can perform DLM operations on the view The view will not be created because the join statements are not allowed for creating a view The view will not be created because the GROUP BY clause is not allowed for creating a view The view will be created but no DML operations will be allowed on the view 4 SC edit delete
178 1Z0-060 See the Exhibits and examine the structures of PRODUCTS, SALES and CUSTOMERS table: 178-qupgrad.png It produces an error because the NATURAL join can be used only with two tables It produces an error because a column used in the NATURAL join cannot have a qualifier It produces an error because all columns used in the NATURAL join should have a qualifier It executes successfully 2 SC edit delete
177 1Z0-060 Exhibit contains the structure of PRODUCTS table: 177-qupgrad.png It produces an error It shows the names of products whose list price is the second highest in the table. It shown the names of all products whose list price is less than the maximum list price It shows the names of all products in the table 2 SC edit delete
176 1Z0-060 You issue the following command to drop the PRODUCTS table: 176-qupgrad.png All data in the table are deleted but the table structure will remain All data along with the table structure is deleted All views and synonyms will remain but they are invalidated The pending transaction in the session is committed All indexes on the table will remain but they are invalidated 2, 3, 4 MC edit delete
175 1Z0-060 See the structure of the PROGRAMS table: 175-qupgrad.png SELECT NVL(ADD_MONTHS(END_DATE,1),SYSDATE) FROM programs; SELECT TO_DATE(NVL(SYSDATE-END_DATE,SYSDATE)) FROM programs; SELECT NVL(MONTHS_BETWEEN(start_date,end_date),'Ongoing') FROM programs; SELECT NVL(TO_CHAR(MONTHS_BETWEEN(start_date,end_date)),'Ongoing') FROM programs; 1, 4 MC edit delete
174 1Z0-060 Which two are true about aggregate functions? (Choose two.) You can use aggregate functions in any clause of a SELECT statement. You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement. You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns. You can pass column names, expressions, constants, or functions as parameter to an aggregate function. You can use aggregate functions on a table, only by grouping the whole table as one single group. You cannot group the rows of a table by more than one column while using aggregate functions. 1, 4 MC edit delete
173 1Z0-060 You need to calculate the number of days from 1st Jan 2007 till date: Dates are stored in the default format of dd-mm-rr. Which two SQL statements would give the required output? (Choose two.) SELECT SYSDATE - TO_DATE('01/JANUARY/2007') FROM DUAL; SELECT TO_DATE(SYSDATE,'DD/MONTH/YYYY')-'01/JANUARY/2007' FROM DUAL; SELECT SYSDATE - TO_DATE('01-JANUARY-2007') FROM DUAL SELECT SYSDATE - '01-JAN-2007' FROM DUAL SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY')-'01-JAN-2007' FROM DUAL; 1, 3 MC edit delete
172 1Z0-060 See the Exhibit and Examine the structure of the CUSTOMERS table: 172-qupgrad.png SELECT NVL(cust_credit_limit,'Not Available')*.15 "NEW CREDIT" FROM customers; SELECT NVL(cust_credit_limit*.15,'Not Available') "NEW CREDIT" FROM customers; SELECT TO_CHAR(NVL(cust_credit_limit*.15,'Not Available')) "NEW CREDIT" FROM customers; SELECT NVL(TO_CHAR(cust_credit_limit*.15),'Not Available') "NEW CREDIT" FROM customers; 4 SC edit delete
171 1Z0-060 See the exhibit and examine the structure of the CUSTOMERS and GRADES tables: 171-qupgrad.png A B C D 171-Aupans.png 171-Bupans.png 171-Cupans.png 171-Dupans.png 2, 3 MC edit delete
170 1Z0-060 Which CREATE TABLE statement is valid? A B C D 170-Aupans.png 170-Bupans.png 170-Cupans.png 170-Dupans.png 4 SC edit delete
169 1Z0-060 Examine the description of the EMP_DETAILS table given below: 169-qupgrad.png An EMP_IMAGE column can be included in the GROUP BY clause You cannot add a new column to the table with LONG as the data type An EMP_IMAGE column cannot be included in the ORDER BY clause You can alter the table to include the NOT NULL constraint on the EMP_IMAGE column 2, 3 MC edit delete
168 1Z0-060 Which two statements are true regarding the COUNT function? (Choose two.) COUNT(*) returns the number of rows including duplicate rows and rows containing NULL value in any of the columns COUNT(cust_id) returns the number of rows including rows with duplicate customer IDs and NULL value in the CUST_ID column COUNT(DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULL values in the INV_AMT column A SELECT statement using COUNT function with a DISTINCT keyword cannot have a WHERE clause The COUNT function can be used only for CHAR, VARCHAR2 and NUMBER data types 1, 3 MC edit delete
167 1Z0-060 Which are SQL*Plus commands? (Choose all that apply.) INSERT UPDATE SELECT DESCRIBE DELETE RENAME 4 SC edit delete
166 1Z0-060 View the Exhibit and examine the structure of the PROMOTIONS table. 166-qupgrad.png A B C D 166-Aupans.png 166-Bupans.png 166-Cupans.png 166-Dupans.png 3 SC edit delete
165 1Z0-060 Which two statements about sub queries are true? (Choose two.) A sub query should retrieve only one row. A sub query can retrieve zero or more rows. A sub query can be used only in SQL query statements. Sub queries CANNOT be nested by more than two levels. A sub query CANNOT be used in an SQL query statement that uses group functions. When a sub query is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the sub query should contain only one column. 2, 6 MC edit delete
164 1Z0-060 View the Exhibit and examine the description for the CUSTOMERS table. 164-qupgrad.png A B C D 164-Aupans.png 164-Bupans.png 164-Cupans.png 164-Dupans.png 2 SC edit delete
163 1Z0-060 View the Exhibit and examine the structure of the CUSTOMERS table. 163-qupgrad.png The VALUES clause cannot be used in an INSERT with a subquery The total number of columns in the NEW_CUSTOMERS table does not match the total number of columns in the CUSTOMERS table The WHERE clause cannot be used in a sub query embedded in an INSERT statement Column names in the NEW_CUSTOMERS and CUSTOMERS tables do not match 1 SC edit delete
162 1Z0-060 Which two statements are true regarding working with dates? (Choose two.) The default internal storage of dates is in the numeric format The RR date format automatically calculates the century from the SYSDATE function but allows the user to enter the century if required The default internal storage of dates is in the character format The RR date format automatically calculates the century from the SYSDATE function and does not allow the user to enter the century 1, 2 MC edit delete
161 1Z0-060 Which statement is true regarding the UNION operator? The number of columns selected in all SELECT statements need to be the same Names of all columns must be identical across all SELECT statements By default, the output is not sorted NULL values are not ignored during duplicate checking 1 SC edit delete
160 1Z0-060 Which two statements are true regarding single row functions? (Choose two.) They can be nested only to two levels They always return a single result row for every row of a queried table Arguments can only be column values or constant They can return a data type value different from the one that is referenced They accept only a single argument 2, 4 MC edit delete
159 1Z0-060 Evaluate the following SQL query; 159-qupgrad.png 200 16 160 150 100 3 SC edit delete
158 1Z0-060 Examine the statement: 158-qupgrad.png An error is generated. You will have two identical tables in the HR schema with different names. You create a table called employees in the HR schema based on you EMP table. You create an alternative name for the employees table in the HR schema in your own schema. 4 SC edit delete
157 1Z0-060 Evaluate this SQL statement: 157-qupgrad.png remove the ORDER BY clause remove the table alias prefix from the WHERE clause remove the table alias from the SELECT clause prefix the column in the USING clause with the table alias prefix the column in the ORDER BY clause with the table alias replace the condition "d.department_id NOT IN (10,40)" in the WHERE clause with "d.department_id <> 10 AND d.department_id <> 40" 2 SC edit delete
156 1Z0-060 The ORDERS TABLE belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR. 156-qupgrad.png CREATE SYNONYM ord FOR orders; This command is issued by OE. CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE. CREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator. CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator. 4 SC edit delete
155 1Z0-060 Which two statements are true about sequences created in a single instance database? (Choose two.) CURRVAL is used to refer to the last sequence number that has been generated DELETE <sequencename> would remove a sequence from the database The numbers generated by a sequence can be used only for one table When the MAXVALUE limit for a sequence is reached, you can increase the MAXVALUE limit by using the ALTER SEQUENCE statement When a database instance shuts down abnormally, the sequence numbers that have been cached but not used would be available once again when the database instance is restarted 1, 4 MC edit delete
154 1Z0-060 Which two statements are true regarding constraints? (Choose two.) A constraint can be disabled even if the constraint column contains data A constraint is enforced only for the INSERT operation on a table A foreign key cannot contain NULL values All constraints can be defined at the column level as well as the table level A columns with the UNIQUE constraint can contain NULL values 1, 5 MC edit delete
153 1Z0-060 Examine the structure of the EMPLOYEES table: 153-qupgrad.png A B C D E 153-Aqupans.png 153-Bqupans.png 153-Cqupans.png 153-Dqupans.png 153-Equpans.png 4 SC edit delete
152 1Z0-060 Evaluate the following SQL statements: 152-qupgrad.png It removes all the rows as well as the structure of the table It removes all the rows in the table and deleted rows cannot be rolled back It removes all the rows in the table and deleted rows can be rolled back It would not remove the rows if the table has a primary key 3 SC edit delete
151 1Z0-060 Evaluate the following SQL statements: 151-qupgrad.png The BETWEEN clause cannot be used for the CHECK constraint SYSDATE cannot be used with the CHECK constraint ORD_NO and ITEM_NO cannot be used as a composite primary key because ORD_NO is also the FOREIGN KEY The CHECK constraint cannot be placed on columns having the DATE data type 2 SC edit delete
150 1Z0-060 You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database 12c. 150-qupgrad.png Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs. Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file. Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view. Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information. 4 SC edit delete
149 1Z0-060 Identify three benefits of Unified Auditing. Decreased use of storage to store audit trail rows in the database. It improves overall auditing performance. It guarantees zero-loss auditing. The audit trail cannot be easily modified because it is read-only. It automatically audits Recovery Manager (RMAN) events. 2, 4, 5 MC edit delete
148 1Z0-060 Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3. Which two RMAN commands may be; used to back up only the PDB1 pluggable database? BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container BACKUP DATABASE while connected to the PDB1 container BACKUP DATABASE while connected to the boot container BACKUP PLUGGABLE database PDB1 while connected to PDB2 1, 3 MC edit delete
147 1Z0-060 On your Oracle 12c database, you Issue the following commands to create indexes 147-qupgrad.png Both the indexes are created; however, only the ORD_COSTOMER index is visible. The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan. Only the ORD_CUSTOMER_IX1 index is created. Only the ORD_CUSTOMER_IX2 index is created. Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table. 1, 5 MC edit delete
146 1Z0-060 A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL: 146-qupgrad.png Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall. Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated. ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring. Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed. 2 SC edit delete
145 1Z0-060 Which two are prerequisites for performing a flashback transaction? Flashback Database must be enabled. Undo retention guarantee for the database must be configured. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction. Supplemental logging must be enabled. Recycle bin must be enabled for the database. Block change tracking must be enabled tor the database. 3, 4 MC edit delete
144 1Z0-060 You are connected to a pluggable database (PDB) as a common user with DBA privileges. 144-qupgrad.png The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted. Nothing happens; because there is no SPFILE for each PDB, the statement is ignored. 1 SC edit delete
143 1Z0-060 In which two scenarios do you use SQL* Loader to load data? Transform the data while it is being loaded into the database. Use transparent parallel processing without having to split the external data first. Load data into multiple tables during the same load statement. Generate unique sequential key values in specified columns. 3, 4 MC edit delete
142 1Z0-060 Examine the following command; 142-qupgrad.png Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file. All DDL commands are logged in the alert log file. All DDL commands are logged in a different log file that contains DDL statements and their execution dates. Only DDL commands that resulted in the creation of new segments are logged. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home. 3 SC edit delete
141 1Z0-060 Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c? By default, EM express is available for a database after database creation. You can use EM express to manage multiple databases running on the same server. You can perform basic administrative tasks for pluggable databases by using the EM express interface. You cannot start up or shut down a database Instance by using EM express. You can create and configure pluggable databases by using EM express. 4 SC edit delete
140 1Z0-060 Which three statements are true about Flashback Database? Flashback logs are written sequentially, and are archived. Flashback Database uses a restored control file to recover a database. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area. Flashback Database can recover a database to the state that it was in before a reset logs operation. Flashback Database can recover a data file that was dropped during the span of time of the flashback. Flashback logs are used to restore to the block's before images, and then the redo data may be used to roll forward to the desired flashback time. 3, 4, 6 MC edit delete
139 1Z0-060 In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement? The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED Setting the target tablespace to read-only The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED Setting the target tablespace offline The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED 2, 3 MC edit delete
138 1Z0-060 Examine the query and its output executed In an RDBMS Instance: 138-qupgrad.png The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only. The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker. The C # # A_ADMIN user can perform wallet operations. The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM). The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus. 2, 4, 5 MC edit delete
137 1Z0-060 Which three statements are true about Oracle Data Pump export and import operations? You can detach from a data pump export job and reattach later. Data pump uses parallel execution server processes to implement parallel import. Data pump import requires the import file to be in a directory owned by the oracle owner. The master table is the last object to be exported by the data pump. You can detach from a data pump import job and reattach later. 1, 4, 5 MC edit delete
136 1Z0-060 Identify two situations in which the alert log file is updated. Running a query on a table returns ORA-600: Internal Error. Inserting a value into a table returns ORA-01722: invalid number. Creating a table returns ORA-00955: name us already in used by an existing objects. Inserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violated. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error. 1, 5 MC edit delete
135 1Z0-060 You Execute the Following command to create a password file in the database server: 135-qupgrad.png It records the usernames and passwords of users when granted the DBA role. It contains the usernames and passwords of users for whom auditing is enabled. Is used by Oracle to authenticate users for remote database administration. It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups. It supports the SYSBACKUP, SYSDG, and SYSKM system privileges. 3, 5 MC edit delete
134 1Z0-060 In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time. How would you accomplish this? Setting a metric threshold Implementing Database Resource Manager Enabling resumable timeout for user sessions Decreasing the value of the IDLE_TIME resource limit in the default profile 4 SC edit delete
133 1Z0-060 Examine these two statements: 133-qupgrad.png The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files. The MRKT tablespace may be dropped if it has no contents. Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace. No more data files can be added to the tablespace. The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace. 3, 4, 5 MC edit delete
132 1Z0-060 You want to flash back a test database by five hours. 132-qupgrad.png The database must have multiplexed redo logs for the flashback to succeed. The database must be MOUNTED for the flashback to succeed. The database must use block change tracking for the flashback to succeed. The database must be opened in restricted mode for the flashback to succeed. The database must be opened with the RESETLOGS option after the flashback is complete. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN. 2, 5 MC edit delete
131 1Z0-060 Which three statements are true about SQL plan directives? They are tied to a specific statement or SQL ID. They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan. They are used to gather only missing statistics. They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect. They instruct the optimizer to create only column group statistics. Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace. 2, 4, 6 MC edit delete
130 1Z0-060 Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command: 130-qupgrad.png It executes successfully and creates an UNDO tablespace in HR_PDB. It falls and reports an error because there can be only one undo tablespace in a CDB. It fails and reports an error because the CONTAINER=ALL clause is not specified in the command. It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command. It executes successfully but neither tablespace nor the data file is created. 5 SC edit delete
129 1Z0-060 Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command: 129-qupgrad.png 1 2 and 4 2 and 5 3 and 4 3 and 5 2 SC edit delete
128 1Z0-060 You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB). 128-qupgrad.png Transportable database Transportable tablespace Data Pump full export / import The DBMS_PDB package RMAN 4 SC edit delete
127 1Z0-060 Which three statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)? System privileges apply only to the PDB in which they are used. Local users cannot use local system privileges on the schema of a common user. The granter of system privileges must possess the set container privilege. Common users connected to a PDB can exercise privileges across other PDBs. System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users. 1, 2, 5 MC edit delete
126 1Z0-060 Examine the commands executed to monitor database operations: 126-qupgrad.png Database operations will be monitored only when they consume a significant amount of resource. Database operations for all sessions will be monitored. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING. Only DML and DDL statements will be monitored for the session. All subsequent statements in the session will be treated as one database operation and will be monitored. 3, 5 MC edit delete
125 1Z0-060 Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs. 125-qupgrad.png Only 1 Only 2 Only 3 3 and 1 1 and 2 4 SC edit delete
124 1Z0-060 The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M; BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M; BACKUP ARCHIVELOG ALL SECTION SIZE 25M; BACKUP TABLESPACE "TEMP" SECTION SIZE 10M; BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M; BACKUP SPFILE SECTION SIZE 1M; BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M; 1, 2, 5, 7 MC edit delete
123 1Z0-060 In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container: 123-qupgrad.png The C # # ROLE1 role is created in the root database and all the PDBs. The C # # ROLE1 role is created only in the root database because the container clause is not used. Privileges are granted to the C##A_ADMIN user only in the root database. Privileges are granted to the C##A_ADMIN user in the root database and all PDBs. The statement for granting a role to a user fails because the CONTAINER clause is not used. 1, 3 MC edit delete
122 1Z0-060 You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns? The index remains invisible. The index is not updated by the DML statements on the indexed table. The index automatically becomes visible in order to have it updated by DML on the table. The index becomes unusable but the table is updated by the DML. The index is updated by the DML on the table. 1, 5 MC edit delete
121 1Z0-060 You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor? It may advise the use of online table redefinition for tables in dictionary managed tablespace. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows. It may advise the use of online table redefinition for tables in locally managed tablespaces It will detect and advise about chained rows. It may advise the use of segment shrink for free list managed tables. 1, 4, 5 MC edit delete
120 1Z0-060 A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions 120-qupgrad.png Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries. Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries. Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column. Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column. Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries. Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries. 1, 3, 5 MC edit delete
119 1Z0-060 Which two statements are true when row archival management is enabled? The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter. The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query. The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active. 3, 4 MC edit delete
118 1Z0-060 On your Oracle Database, you issue the following commands to create indexes: 118-qupgrad.png Only the ORD_CUSTOMER_IX1 index created. Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table. Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table. The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true. Both the indexes are created and used by the optimizer for queries on the ORDERS table. Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table. 2, 6 MC edit delete
117 1Z0-060 You created an encrypted tablespace: 117-qupgrad.png It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT. It generates an error when creating the table because the wallet is closed. It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation. It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces. 2 SC edit delete
116 1Z0-060 Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Database Resource Manager? Maximum Undo per consumer group Maximum Idle time Parallel server limit CPU Exadata I/O Local file system 1, 4, 5 MC edit delete
115 1Z0-060 You find this query being used in your Oracle 12c database: 115-qupgrad.png A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application. A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows. A TOP-N query is created to limit the rows to 20 percent of the total rows 3 SC edit delete
114 1Z0-060 You performed an incremental level 0 backup of a database: 114-qupgrad.png Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups. The change tracking file must always be backed up when you perform a full database backup. Block change tracking will always reduce I/O performed during cumulative incremental backups. More than one database block may be read by an incremental backup for a change made to a single block. The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks. 1, 4, 5 MC edit delete
113 1Z0-060 Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container: 113-qupgrad.png Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs. The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root. The command will, create a common user whose description is contained in the root and each PDB. The schema for the common user C # # A_ADMIN can be different in each container. The command will create a user in the root container only because the container clause is not used. 3, 4 MC edit delete
112 1Z0-060 Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. 112-qupgrad.png When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started. When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started. When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration. When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration. 2 SC edit delete
111 1Z0-060 Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)? A DBA can check specific tables with the DMU The database to be migrated must be opened read-only. The release of the database to be converted can be any release since 9.2.0.8. The DMU can report columns that are too long in the converted characterset. The DMU can report columns that are not represented in the converted characterset. 1, 4, 5 MC edit delete
110 1Z0-060 You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. 110-qupgrad.png The valid time columns employee_time_start and employee_time_end are automatically created. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses. The valid time columns are not populated by the Oracle Server automatically. The valid time columns are visible by default when the table is described. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session. 1, 2, 5 MC edit delete
109 1Z0-060 Which three activities are supported by the Data Recovery Advisor? Advising on block checksum failures Advising on inaccessible control files Advising on inaccessible block change tracking files Advising on empty password files Advising on invalid block header field values 1, 2, 5 MC edit delete
108 1Z0-060 What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving enabled? It fails with the ORA-665610 Invalid DDL statement on history-tracked message The rows in the table are truncated without being archived. The rows in the table are archived, and then truncated. The rows in both the table and the archive are truncated. 3 SC edit delete
107 1Z0-060 A redaction policy was added to the SAL column of the SCOTT.EMP table: 107-qupgrad.png SYS sessions, regardless of the roles that are set in the session SYSTEM sessions, regardless of the roles that are set in the session SCOTT sessions, only if the MGR role is set in the session SCOTT sessions, only if the MGR role is granted to SCOTT SCOTT sessions, because he is the owner of the table SYSTEM session, only if the MGR role is set in the session 1, 2, 4 MC edit delete
106 1Z0-060 You enabled an audit policy by issuing the following statements: 106-qupgrad.png SYS, SYSTEM SCOTT Only for successful executions Only for failed executions Both successful and failed executions 1, 5 MC edit delete
105 1Z0-060 Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report: 105-qupgrad.png The size of the shared pool is too small. Cursors are not being shared. A large number COMMITS are being performed. There are frequent logons and logoffs. The buffers are being read into the buffer cache, but some other session is changing the buffers. 1, 2, 5 MC edit delete
104 1Z0-060 You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements: 104-qupgrad.png It succeeds because the PDB_ADMIN user has the required privileges. It fails because common users are unable to use the SET CONTAINER statement. It fails because local users are unable to use the SET CONTAINER statement. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB). 3 SC edit delete
103 1Z0-060 Which three operations can be performed as multipartition operations in Oracle? Merge partitions of a list partitioned table Drop partitions of a list partitioned table Coalesce partitions of a hash-partitioned global index. Move partitions of a range-partitioned table Rename partitions of a range partitioned table Merge partitions of a reference partitioned index 1, 2, 6 MC edit delete
102 1Z0-060 Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In UNIX? Thread creation must be routed through a dispatcher process The local listener may spawn a now process and have that new process create a thread Each Oracle process runs an SCMN thread. Each multithreaded Oracle process has an SCMN thread. The local listener may pass the request to an existing process which in turn will create a thread. 1, 4, 5 MC edit delete
101 1Z0-060 Examine the parameters for your database instance: 101-qupgrad.png The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics. The optimizer can re optimize a query only once using cardinality feedback. The optimizer enables monitoring for cardinality feedback after the first execution of a query. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer. 1, 3, 4 MC edit delete
100 1Z0-060 Which two statements are true about the Oracle Direct Network File system (DNFS)? It utilizes the OS file system cache. A traditional NFS mount is not required when using Direct NFS. Oracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver. Direct NFS is available only in UNIX platforms. Direct NFS can load-balance I/O traffic across multiple network adapters. 3, 5 MC edit delete
99 1Z0-060 In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer. Which statement is true? The CDB must be open. The CDB must be in the mount stage. The CDB must be in the nomount stage. Alt existing PDBs must be closed. 1 SC edit delete
98 1Z0-060 You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB). 98-qupgrad.png 2, 1, 3, 4, 5, 6 1, 3, 4, 5, 6, 7 1, 4, 3, 5, 6, 7 2, 1, 3, 4, 5, 6, 7 1, 5, 6, 4, 3, 2 3 SC edit delete
97 1Z0-060 You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name. Which statement is true? The ORACLE_BASE base parameter is not set. The installation is being performed by the root user. The operating system group that is specified should have the root user as its member. The operating system group that is specified must have permission to write to the inventory directory. 4 SC edit delete
96 1Z0-060 Which two statements are true about the RMAN validate database command? It checks the database for intrablock corruptions. It can detect corrupt pfiles. It can detect corrupt spfiles. It checks the database for interblock corruptions. It can detect corrupt block change tracking files. 1, 3 MC edit delete
95 1Z0-060 Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyze impact on the performance of SQL statements. Change in the Oracle Database version Change in your network infrastructure Change in the hardware configuration of the database server Migration of database storage from non-ASM to ASM storage Database and operating system upgrade 1, 3, 5 MC edit delete
94 1Z0-060 Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN. 94-qupgrad.png Place the root container in ARHCHIVELOG mode. Take the user data tablespace offline. Place the root container in the nomount stage. Ensure that HR_PDB is open. 1 SC edit delete
93 1Z0-060 Which three actions are possible during an Online Data file Move operation? Creating and dropping tables in the data file being moved Performing file shrink of the data file being moved Querying tables in the data file being moved Performing Block Media Recovery for a data block in the data file being moved Flashing back the database Executing DML statements on objects stored in the data file being moved 1, 3, 6 MC edit delete
92 1Z0-060 Which two statements are true about Oracle Managed Files (OMF)? OMF cannot be used in a database that already has data files created with userspecified directions. The file system directions that are specified by OMF parameters are created automatically. OMF can be used with ASM disk groups, as well as with raw devices, for better file management. OMF automatically creates unique file names for table spaces and control files. OMF may affect the location of the redo log files and archived log files. 4, 5 MC edit delete
91 1Z0-060 You configure your database Instance to support shared server connections. Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection? User session data Stack space Private SQL area Location of the runtime area for DML and DDL Statements Location of a part of the runtime area for SELECT statements 1, 3 MC edit delete
90 1Z0-060 Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c? ALTER TABLE SPLIT PARTITION ALTER TABLE MERGE PARTITION ALTER TABLE TRUNCATE PARTITION ALTER TABLE ADD PARTITION ALTER TABLE DROP PARTITION ALTER TABLE MOVE PARTITION 3, 5 MC edit delete
89 1Z0-060 Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)? Tracking the most recent read time for a table segment in a user tablespace Tracking the most recent write time for a table segment in a user tablespace Tracking insert time by row for table rows Tracking the most recent write time for a table block Tracking the most recent read time for a table segment in the SYSAUX tablespace Tracking the most recent write time for a table segment in the SYSAUX tablespace 1, 2, 4 MC edit delete
88 1Z0-060 A senior DBA asked you to execute the following command to improve performance: 88-qupgrad.png The keep pool is not configured. Automatic Workarea Management is not configured. Automatic Shared Memory Management is not enabled. The data blocks in the SUBSCRIBE_LOG table are rarely accessed. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view. 4 SC edit delete
87 1Z0-060 You are administering a database and you receive a requirement to apply the following restrictions: 87-qupgrad.png By granting a secure application role to the users By creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to FALSE By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4 By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE. By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4. 3 SC edit delete
86 1Z0-060 You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy. 86-qupgrad.png Increase the value of the ASM_POWER_LIMIT parameter. Set the DISK_REPAIR_TIME disk attribute to a lower value. Specify the statement that adds the disk back to the disk group. Increase the number of ASMB processes. Increase the number of DBWR_IO_SLAVES in the ASM instance. 1, 3 MC edit delete
85 1Z0-060 Identify three valid methods of opening, pluggable databases (PDBs). ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a PDB ALTER PLUGGABLE DATABASE PDB OPEN issued from the seed ALTER DATABASE PDB OPEN issued from the root ALTER DATABASE OPEN issued from that PDB ALTER PLUGGABLE DATABASE PDB OPEN issued from another PDB ALTER PLUGGABLE DATABASE OPEN issued from that PDB 1, 5, 7 MC edit delete
84 1Z0-060 You executed this command to create a password file: 84-qupgrad.png It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role. It contains username and passwords of database users who are members of the OSOPER operating system group. It contains usernames and passwords of database users who are members of the OSDBA operating system group. It will permit the use of lowercase passwords for database users who have granted the SYSDBA role. It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role. 1, 4 MC edit delete
83 1Z0-060 To enable the Database Smart Flash Cache, you configure the following parameters: 83-qupgrad.png It results in an error because these parameter settings are invalid. One 64G flash cache file will be used. Two 64G flash cache files will be used. Two 32G flash cache files will be used. 1 SC edit delete
82 1Z0-060 You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group? The ASM compatibility attribute controls the format of the disk group metadata. RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group. The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group. The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group. The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10 g database. 1, 2, 4 MC edit delete
81 1Z0-060 You execute the following commands to audit database activities: 81-qupgrad.png One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements. One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used. 4 SC edit delete
80 1Z0-060 You execute the following PL/SQL: 80-qupgrad.png Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed. FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed. FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column. FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial. 1, 4 MC edit delete
79 1Z0-060 Which three statements are true about using flashback database in a multitenant container database (CDB)? The root container can be flashed back without flashing back the pluggable databases (PDBs). To enable flashback database, the CDB must be mounted. Individual PDBs can be flashed back without flashing back the entire CDB. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point. 2, 4, 5 MC edit delete
78 1Z0-060 Your database is open and the LISTENER listener running. You stopped the wrong listener 77-qupgrad.png They are able to perform only queries. They are not affected and continue to function normally. They are terminated and the active transactions are rolled back. They are not allowed to perform any operations until the listener LISTENER is started. 2 SC edit delete
77 1Z0-060 You execute the following piece of code with appropriate privileges: 77-qupgrad.png Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set. Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set. Data is never redacted for the EMP_V.SAL column. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set. 1, 3 MC edit delete
76 1Z0-060 You run a script that completes successfully using SQL*Plus that performs these actions: 76-qupgrad.png The seed will be in mount state. The seed will be opened read-only. The seed will be opened read/write. The other PDBs will be in mount state. The other PDBs will be opened read-only. The PDBs will be opened read/write. 2, 4 MC edit delete
75 1Z0-060 You plan to migrate your database from a File system to Automata Storage Management (ASM) on same platform. Which two methods or commands would you use to accomplish this task? RMAN CONVERT command Data Pump Export and import Conventional Export and Import The BACKUP AS COPY DATABASE . . . command of RMAN DBMS_FILE_TRANSFER with transportable tablespace 1, 4 MC edit delete
74 1Z0-060 You notice that the elapsed time for an important database scheduler Job is unacceptably long. The job belongs to a scheduler job class and window. Which two actions would reduce the job's elapsed time? Increasing the priority of the job class to which the job belongs Increasing the job's relative priority within the Job class to which it belongs Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window Moving the job to an existing higher priority scheduler window with the same schedule and duration Increasing the value of the JOB_QUEUE_PROCESSES parameter Increasing the priority of the scheduler window to which the job belongs 3, 6 MC edit delete
73 1Z0-060 Which three statements are true concerning the multitenant architecture? Each pluggable database (PDB) has its own set of background processes. A PDB can have a private temp tablespace. PDBs can share the sysaux tablespace. Log switches occur only at the multitenant container database (CDB) level. Different PDBs can have different default block sizes. PDBs share a common system tablespace. Instance recovery is always performed at the CDB level. 2, 4, 7 MC edit delete
72 1Z0-060 You use a recovery catalog for maintaining your database backups. 72-qupgrad.png Corrupted blocks, if any, are repaired. Checks are performed for physical corruptions. Checks are performed for logical corruptions. Checks are performed to confirm whether all database files exist in correct locations Backup sets containing both data files and archive logs are created. 2, 4 MC edit delete
71 1Z0-060 Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB. In a PDB plan, subplans may be used with up to eight consumer groups. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan. 1, 5 MC edit delete
70 1Z0-060 In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. 70-qupgrad.png It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only. It fails and reports an error because the CONTAINER=ALL clause is not used. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs. It fails and reports an error because the CONTAINER=CURRENT clause is not used. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs. 1 SC edit delete
69 1Z0-060 Examine the contents of SQL loader control file: 69-qupgrad.png An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data. The SQL* Loader data file myfile1.dat has the column names for the EMP table. The SQL* Loader operation fails because no record terminators are specified. Field names should be the first line in the both the SQL* Loader data files. The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator. 1, 2, 5 MC edit delete
68 1Z0-060 Examine the following parameters for a database instance: 68-qupgrad.png LOG_BUFFER SORT_AREA_SIZE JAVA_POOL_SIZE STREAMS_POOL_SIZE DB_16K_CACHE_SZIE DB_KEEP_CACHE_SIZE 1, 5, 6 MC edit delete
67 1Z0-060 You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux. 67-qupgrad.png Set DB_FLASH_CACHE_SIZE = 64G. Set DB_FLASH_CACHE_SIZE = 64G, 64G Set DB_FLASH_CACHE_SIZE = 128G. DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup. 2 SC edit delete
66 1Z0-060 What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE” statement? It will create a multitenant container database (CDB) with only the root opened. It will create a CDB with root opened and seed read only. It will create a CDB with root and seed opened and one PDB mounted. It will create a CDB that must be plugged into an existing CDB. It will create a CDB with root opened and seed mounted. 2 SC edit delete
65 1Z0-060 You created a new database using the "create database" statement without specifying the "ENABLE PLUGGABLE" clause. What are two effects of not using the "ENABLE PLUGGABLE database" clause? The database is created as a non-CDB and can never contain a PDB. The database is treated as a PDB and must be plugged into an existing multitenant container database (CDB). The database is created as a non-CDB and can never be plugged into a CDB. The database is created as a non-CDB but can be plugged into an existing CDB. The database is created as a non-CDB but will become a CDB whenever the first PDB is plugged in. 1, 4 MC edit delete
64 1Z0-060 In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure: 64-qupgrad.png Create the CREATE_TEST procedure with definer’s rights. Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure. Create the CREATE_TEST procedure with invoker’s rights. Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package. 3 SC edit delete
63 1Z0-060 You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the OCP schema. 63-qupgrad.png Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO OCP.EXAM_RESULTS; connected as SYSTEM. Recover the table using traditional Tablespace Point In Time Recovery. Recover the table using Automated Tablespace Point In Time Recovery. Recovery the table using Database Point In Time Recovery. Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO EXAM_RESULTS; connected as the OCP user. 3 SC edit delete
62 1Z0-060 Which two statements are true about variable extent size support for large ASM files? The metadata used to track extents in SGA is reduced. Rebalance operations are completed faster than with a fixed extent size An ASM Instance automatically allocates an appropriate extent size. Resync operations are completed faster when a disk comes online after being taken offline. Performance improves in a stretch cluster configuration by reading from a local copy of an extent. 1, 3 MC edit delete
61 1Z0-060 You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces are created by default in HR_PDB? SYSTEM SYSAUX EXAMPLE UNDO TEMP USERS 1, 2, 5 MC edit delete
60 1Z0-060 Which three statements are true about adaptive SQL plan management? It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans. The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline. It adds new, bettor plans automatically as fixed plans to the baseline. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans. The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated. 1, 4, 5 MC edit delete
59 1Z0-060 Examine the parameter for your database instance: 59-qupgrad.png The optimizer used a dynamic plan for the query. The optimizer chose different plans because automatic dynamic sampling was enabled. The optimizer used re-optimization cardinality feedback for the query. The optimizer chose different plan because extended statistics were created for the columns used. 2 SC edit delete
58 1Z0-060 You notice a performance change in your production Oracle database and you want to know which change has made this performance difference. You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation. Which three findings would you get from the report? It detects any configuration change that caused a performance difference in both time periods. It identifies any workload change that caused a performance difference in both time periods. It detects the top wait events causing performance degradation. It shows the resource usage for CPU, memory, and I/O in both time periods. It shows the difference in the size of memory pools in both time periods. It gives information about statistics collection in both time periods. 1, 2, 4 MC edit delete
57 1Z0-060 Examine the following query output: 57-qupgrad.png All database operations performed by the impdp command are logged. Only CREATE INDEX and CREATE TABLE statements generated by the import are logged. Only CREATE TABLE and ALTER TABLE statements generated by the import are logged. None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged. 3 SC edit delete
56 1Z0-060 An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges. 56-qupgrad.png You can conned as a common user by using the connect statement. You can connect as a local user by using the connect statement. You can connect by using easy connect. You can connect by using OS authentication. You can connect by using a Net Service name. You can connect as a local user by using the SET CONTAINER statement. 1, 3, 4, 5 MC edit delete
55 1Z0-060 Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this? Database replay SQL Tuning Advisor SQL Access Advisor SQL Performance Analyzer Automatic Workload Repository compare reports 4 SC edit delete
54 1Z0-060 You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB). 54-qupgrad.png Transportable database Transportable tablespace Data Pump full export/import The DBMS_PDB package RMAN 2 SC edit delete
53 1Z0-060 You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. You plan to create the database using SQL statements. Which three techniques can you use to achieve this? Use Oracle Managed Files (OMF). Specify the SEED FILE_NAME_CONVERT clause. Specify the PDB_FILE_NAME_CONVERT initialization parameter. Specify the DB_FILE_NAMECONVERT initialization parameter. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF). 1, 2, 3 MC edit delete
52 1Z0-060 You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege. 52-qupgrad.png The shutdown proceeds immediately. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled hack. The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back. The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back. The statement results in an error because there are open PDBs. 2 SC edit delete
51 1Z0-060 An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would you guarantee that the blocks for the table never age out? Configure the KEEP buffer pool and alter the table with the corresponding storage clause. Increase the database buffer cache size. Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause. Configure Automata Shared Memory Management. Configure Automatic Memory Management. 1 SC edit delete
50 1Z0-060 You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). 50-qupgrad.png Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes. Re-create the password file in the Oracle Database 12c format. 2, 4 MC edit delete
49 1Z0-060 Which three statements are true about Automatic Workload Repository (AWR)? All AWR tables belong to the SYSTEM schema. The AWR data is stored in memory and in the database. The snapshots collected by AWR are used by the self-tuning components in the database AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views. AWR contains system wide tracing and logging information. 3, 4, 5 MC edit delete
48 1Z0-060 You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema. 48-qupgrad.png 3, 2, 1, 4 2, 3, 4, 1 4, 1, 3, 2 3, 2, 4, 1 2 SC edit delete
47 1Z0-060 You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use? Compare Period ADDM report AWR Compare Period report Active Session History (ASH) report Taking a new snapshot and comparing it with a preserved snapshot 2 SC edit delete
46 1Z0-060 Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges? Bind Variable Peeking SQL Plan Baselines Adaptive Cursor Sharing Bind variable used in a SQL statement Literals in a SQL statement 1, 3, 5 MC edit delete
45 1Z0-060 You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed. Identify three possible reasons for this. Missing or stale histogram statistics Undersized shared pool High clustering factor for the indexes High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter Oversized buffer cache 1, 3, 4 MC edit delete
44 1Z0-060 Which two statement is true concerning dropping a pluggable database (PDB)? The PDB must be open in read-only mode. The PDB must be in mount state. The PDB must be unplugged. The PDB data files are always removed from disk. A dropped PDB can never be plugged back into a multitenant container database (CDB). 3, 4 MC edit delete
43 1Z0-060 You upgrade your Oracle database in a multiprocessor environment. 43-qupgrad.png Parallel compilation of only the stored PL/SQL code Sequential recompilation of only the stored PL/SQL code Parallel recompilation of any stored PL/SQL code Sequential recompilation of any stored PL/SQL code Parallel recompilation of Java code Sequential recompilation of Java code 3, 5 MC edit delete
42 1Z0-060 Identify two correct statements about multitenant architectures. Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration. Multiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources. Multiple CDBs share certain PDB resources. Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server. Patches are always applied at the CDB level. A PDB can have a private undo tablespace. 2, 5 MC edit delete
41 1Z0-060 What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database? Effectively implements role separation Enables you to take advantage of Oracle Managed Files. Automatically registers the database with Oracle Restart. Helps you to easily upgrade the database from a prior release. Enables the Installation of Grid Infrastructure files on block or raw devices. 3, 5 MC edit delete
40 1Z0-060 To implement Automatic Management (AMM), you set the following parameters: 40-qupgrad.png The PGA_AGGREGATE_TARGET parameter is set to zero. The STATISTICS_LEVEL parameter is set to BASIC. Both the SGA_TARGET and MEMORY_TARGET parameters are set. The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal. 2 SC edit delete
39 1Z0-060 Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application? Oracle Data Pump. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes. Online Table Redefinition. Edition-Based Table Redefinition. 4 SC edit delete
38 1Z0-060 You must track all transactions that modify certain tables in the sales schema for at least three years. Automatic undo management is enabled for the database with a retention of one day. Which two must you do to track the transactions? Enable supplemental logging for the database. Specify undo retention guarantee for the database. Create a Flashback Data Archive in the tablespace where the tables are stored. Create a Flashback Data Archive in any suitable tablespace. Enable Flashback Data Archiving for the tables that require tracking. 4, 5 MC edit delete
37 1Z0-060 After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows: 37-qupgrad.png Re-enable redaction policies that use FULL data redaction. Re-create redaction policies that use FULL data redaction. Re-connect the sessions that access objects with redaction policies defined on them. Flush the shared pool. Restart the database instance. 5 SC edit delete
36 1Z0-060 On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: 36-qupgrad.png It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database. It fails because no SQL *Loader data file location is specified. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege. It fails because no SQL *Loader control file location is specified. 1, 3 MC edit delete
35 1Z0-060 You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT. 35-qupgrad.png All users except SYS All users except SCOTT All users except sys and SCOTT All users except sys, system, and SCOTT 2 SC edit delete
34 1Z0-060 Examine the following command: 34-qupgrad.png The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output. The DESCRIBE commands in SQL *Plus will not display the invisible column in the output. Referential integrity constraint cannot be set on the invisible column. The invisible column cannot be made visible and can only be marked as unused. A primary key constraint can be added on the invisible column. 1, 2, 5 MC edit delete
33 1Z0-060 Which three statements are true concerning unplugging a pluggable database (PDB)? The PDB must be open in read only mode. The PDB must be dosed. The unplugged PDB becomes a non-CDB. The unplugged PDB can be plugged into the same multitenant container database (CDB) The unplugged PDB can be plugged into another CDB. The PDB data files are automatically removed from disk. 1, 4, 5 MC edit delete
32 1Z0-060 Examine the current value for the following parameters in your database instance: 32-qupgrad.png It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically. It succeeds only if memory is available from the autotuned components if SGA. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE. 4 SC edit delete
31 1Z0-060 Which two are true concerning a multitenant container database with three pluggable database? All administration tasks must be done to a specific pluggable database. The pluggable databases increase patching time. The pluggable databases reduce administration effort. The pluggable databases are patched together. Pluggable databases are only used for database consolidation. 3, 5 MC edit delete
30 1Z0-060 Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source): 30-qupgrad.png The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role. All the user-defined tablespaces must be in read-only mode on the source database. The export dump file must be created before starting the import on the target database. The source and target database must be running on the same platform with the same endianness. The path of data files on the target database must be the same as that on the source database. The impdp operation must be performed by the same user that performed the expdp operation. 1, 2, 4 MC edit delete
29 1Z0-060 Examine this command: 29-qupgrad.png Statistics collection is not done for the CUSTOMERS table when schema stats are gathered. Statistics collection is not done for the CUSTOMERS table when database stats are gathered. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics. 3, 4, 5 MC edit delete
28 1Z0-060 In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. 28-qupgrad.png Decreasing PCTUSED Decreasing PCTFREE Increasing the number of DBWN process Using Automatic Segment Space Management (ASSM) Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation 4 SC edit delete
27 1Z0-060 The following parameter are set for your Oracle 12c database instance: 27-qupgrad.png 2, 4, 5 2, 1, 4, 3, 5 1, 2, 3, 4, 5 1, 2, 4, 5 2 SC edit delete
26 1Z0-060 Your database supports a DSS workload that involves the execution of complex queries: 26-qupgrad.png Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS. Run the Automatic Workload Repository Monitor (ADDM). Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS. Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS. 4 SC edit delete
25 1Z0-060 Identify two valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB). Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED. Use the CREATE DATABASE . . . ENABLE PLUGGABLE DATABASE statement to provision a PDB by copying file from the SEED. Use the DBMS_PDB package to clone an existing PDB. Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB. Use the DBMS_PDB package to plug an Oracle 11 g Release 2 (11.2.0.3.0) non-CDB database into an existing CDB. 1, 4 MC edit delete
24 1Z0-060 A new report process containing a complex query is written, with high impact on the database. 24-qupgrad.png Execute the query and view Active Session History (ASH) for information about the query. Enable SQL trace for the query. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the report. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view. 3 SC edit delete
23 1Z0-060 Your multitenant container database (CDB) contains three pluggable database (PDBs). 23-qupgrad.png Mount the container database (CDB) and restore the control file from the control file auto backup. Recover and open the CDB in NORMAL mode. Mount the CDB and then recover and open the database, with the RESETLOGS option. Open all the pluggable databases. Recover each pluggable database. Start the database instance in the nomount stage and restore the control file from control file auto backup. 3, 4, 6 MC edit delete
22 1Z0-060 Examine the Following command 22-qupgrad.png None of the data definition language (DDL) statements are logged in the trace file. Only DDL commands that resulted in errors are logged in the alert log file. A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file. Only DDL commands that resulted in the creation of new database files are logged. 1 SC edit delete
21 1Z0-060 Which three functions are performed by the SQL Tuning Advisor? Building and implementing SQL profiles Recommending the optimization of materialized views Checking query objects for missing and stale statistics Recommending bitmap, function-based, and B-tree indexes Recommending the restructuring of SQL queries that are using bad 1, 3, 5 MC edit delete
20 1Z0-060 You are administering a database stored in Automatic Storage management (ASM). 20-qupgrad.png The file +data.231.54769' is physically relocated to +data/prod' and renamed as myfile.dbf'. The file +data.231.54769' is renamed as myfile.dbf', and copied to +data/prod'. The file '+data.231.54769' remains in the same location and a synonym 'myfile.dbf' is created. The file myfile.dbf' is created in +data/prod` and the reference to +data.231.54769' in the data dictionary removed. 3 SC edit delete
19 1Z0-060 Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Data files that belong to only the root container Data files that belong to the root container and all the pluggable databases (PDBs) Data files that belong to only the root container and PDB$SEED Data files that belong to the root container and all the PDBs excluding PDB$SEED 2 SC edit delete
18 1Z0-060 You database is running an ARCHIVELOG mode. 18-qupgrad.png They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter. They are created only in the Fast Recovery Area. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter. 1 SC edit delete
17 1Z0-060 Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users: 17-qupgrad.png 1, 3, 5, 6, 2, 4 1, 3, 6, 2, 5, 4 1, 3, 2, 5, 6, 4 1, 3, 2, 5, 6, 4 1, 3, 5, 2, 6, 4 2 SC edit delete
16 1Z0-060 The tnsnames.ora file has an entry for the service alias ORCL as follows: 16-qupgrad.png The listener is not running on the database node. The TNS_ADMIN environment variable is set to the wrong value. The orcl.oracle.com database service is not registered with the listener. The orcl.oracle.com database service is not registered with the listener. The listener is running on a different port. 3 SC edit delete
15 1Z0-060 In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation. How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions? It collects data from SGA and compares it with a preserved snapshot. It collects data from SGA, analyzes it, and provides a report. It collects data from SGA and compares it with the latest snapshot. It collects data from both SGA and PGA, analyzes it, and provides a report. 2 SC edit delete
14 1Z0-060 You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format. Which three storage options support the use of HCC? ASM disk groups with ASM disks consisting of Exadata Grid Disks. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files Database files stored in ZFS and accessed using conventional NFS mounts. Database files stored in ZFS and accessed using the Oracle Direct NFS feature Database files stored in any file system and accessed using the Oracle Direct NFS feature ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays 1, 5, 7 MC edit delete
13 1Z0-060 You notice that the performance of your production 24/7 Oracle database significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance. How can you detect the cause of the degraded performance? Enable Memory Access Mode, which reads performance data from SGA. Use emergency monitoring to fetch data directly from SGA analysis. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots. Use Active Session History (ASH) data and hang analysis in regular performance monitoring. Run ADDM in diagnostic mode. 2 SC edit delete
12 1Z0-060 What are three purposes of the RMAN “FROM” clause? To support PUSH-based active database duplication To support synchronization of a standby database with the primary database in a Data environment To support PULL-based active database duplication To support file restores over the network in a Data Guard environment To support file recovery over the network in a Data Guard environment 2, 4, 5 MC edit delete
11 1Z0-060 Which three are true about the large pool for an Oracle database instance that supports shared server connections? Allocates memory for RMAN backup and restore operations Allocates memory for shared and private SQL areas Contains a cursor area for storing runtime information about cursors Contains stack space Contains a hash area performing hash joins of tables 1, 2, 3 MC edit delete
10 1Z0-060 In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database? 10-qupgrad.png The partitions can be moved online to new tablespaces. Global indexes must be rebuilt manually after moving the partitions. The partitions can be compressed in the same tablespaces. The partitions can be compressed in the new tablespaces. Local indexes must be rebuilt manually after moving the partitions. 1, 3, 4 MC edit delete
9 1Z0-060 Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? Reduced logical I/O Reduced virtual memory utilization Improved parallel Execution performance Improved Serial Execution performance Reduced physical I/O Reduced CPU utilizati 2, 3, 6 MC edit delete
8 1Z0-060 Your Multitenant container(CDB) containing three pluggable database(PDB) 8-qupgrad.png 6, 5, 4, 7 10, 1, 2, 5, 8 10, 1, 2, 5, 4, 9, 8 10, 1, 5, 8, 10 1 SC edit delete
7 1Z0-060 Which Oracle Database component is audited by default if the unified Auditing option is enabled? Oracle Data Pump Oracle Recovery Manager (RMAN) Oracle Label Security Oracle Database Vault Oracle Real Application Security 2 SC edit delete
6 1Z0-060 Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database. You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted. What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB? Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDB. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command. Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command. Take the USERDATA tablespace offline in ACCOUNTS_PDB. 4 SC edit delete
5 1Z0-060 You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure. In which three ways can you re-create the lost disk group and restore the data? Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data 3, 4, 6 MC edit delete
4 1Z0-060 Which statement is true about Oracle Net Listener? It acts as the listening endpoint for the Oracle database instance for all local and nonlocal user connections. A single listener can service only one database instance and multiple remote client connections. Service registration with the listener is performed by the process monitor (LREG) process of each database instance. The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance. The listener.ora configuration file must be located in the ORACLE_HOME/network/admin directly. 3 SC edit delete
3 1Z0-060 Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column? The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace. All the components may be moved into SYSAUX tablespace. All the components may be moved from the SYSAUX tablespace. 1, 2 MC edit delete
2 1Z0-060 Examine the following commands for redefining a table with Virtual Private Database (VPD) policies: 2-qupgrad.png All the triggers for the table are disabled without changing any of the column names or column types in the table. The primary key constraint on the EMPLOYEES table is disabled during redefinition. VPD policies are copied from the original table to the new table during online redefinition. You must copy the VPD policies manually from the original table to the new table during online redefinition. 1, 3 MC edit delete
1 1Z0-060 Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp. 1-qupgrad.png Add a new temp file to the temporary tablespace and drop the temp file that that produced the error. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database. Take the temporary tablespace offline, recover the missing temp file by applying redo logs, and then bring the temporary tablespace online. Shutdown the database instance, restore and recover the temp file from the backup, and then open the database with RESETLOGS. Shut down the database instance and then restart the CDB and PDBs. 1, 5 MC edit delete

Copyright © Designed & Developed by Sakthi Db Technology 2018